﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MusicOnSpace
{
    public class Banner
    {
        private string bannerId;

        public string BannerId
        {
            get { return bannerId; }
            set { bannerId = value; }
        }
        private string bannerName;

        public string BannerName
        {
            get { return bannerName; }
            set { bannerName = value; }
        }
        private string bannerUrl;

        public string BannerUrl
        {
            get { return bannerUrl; }
            set { bannerUrl = value; }
        }

        List<Banner> BannerList = new List<Banner>();
        dataProvider dp = new dataProvider();

        public void InsertBannerber(string id, string name, string url)
        {
            string command = "Insert into Banner (bannerId, bannerName, bannerUrl) values (" + id + "," + name + "," + url + ")";

            dp.ExeCuteNonQuery(command);
        }

        public void DeleteBannerber(string id)
        {
            string command = "";
            dp.ExeCuteNonQuery(command);
        }

        public void BannerSearch(string name)
        {
            string command = "Select * from Banner where name like 'N" + name + "'";
            dp.ExeCuteNonQuery(command);
        }

        public void GetBannerber()
        {

        }

        public List<Banner> AddBanner()
        {
            //SqlCommand cmd = new SqlCommand ("Insert into Bannerber (
            return BannerList;
        }
    }
}